Creating Test Cases

You can create test cases at map level to give a testing procedure more granularity.

To create test cases at map level, follow these steps:

  1. Go to Application Menu > Data Catalog > Mapping Manager > Workspace Mappings.
  2. Click the required map and click the Test Specification tab.
  3. The following page appears. You can see a test case which was created at project level. Test cases created at project level are applicable to all the maps under the project.

  4. Click .
  5. The Add New Test Case page appears.

  6. Enter appropriate values in the fields. Fields marked with a red asterisk are mandatory. Refer to the following table for field descriptions.
  7. Field Name

    Description

    Test Case Name

    Specifies the name of the test case.

    For example, Verifying the Completeness of Source Metadata.

    Test Case Label

    Specifies the unique label for the test case.

    For example, Source Metadata.

    Priority

    Specifies the priority of the test case.

    For example, High. Priority for business rules and functional test cases can be medium or higher.

    Type of Testing

    Specifies the type of testing.

    For example, Metadata Testing.

    Extendable

    Specifies whether the test case is visible even when this map is archived.

    A map is archived whenever you create a new version of the map.

    Test SQL Script

    Specifies the SQL script required in the test execution.

    For example, select * from dbo.ADS_ASSOCIATIONS.

    Description

    Specifies the test objective in brief.

    For example: The objective of the test case is to verify the completeness of source metadata.

    Expected Result

    Specifies the expected result of the test case in detail.

    For example: The source table should have 50 columns.

    Actual Result

    Specifies the actual test result after the execution of the test.

    For example: The source table has 39 columns.

    Testing Comments

    Specifies the testing comments about the test case.

    For example: The source metadata was scanned from a Sql Server database.

    Test Case Status

    Specifies the status of the test case.

    For example, Passed.

    Approved

    Specifies whether the test case is approved.

  8. Click Save and Exit.
  9. The test case is added under the Test Specification tab.

Once a test case is created, you can enrich it by:

Managing test cases involves:

  • Updating test case status
  • Approving test cases
  • Exporting test cases
  • Deleting test cases